StudentAcademicYear 
EntityType  Independent 
Logical Entity Name  StudentAcademicYear 
Default Table Name  FaStudentAY 
Logical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

StudentAcademicYear Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
StudentAcademicYearId(PK)    INTEGER  NO 
 
StudentEnrollmentPeriodId(FK)    INTEGER  NO 
 
AcademicYearId    INTEGER  NO 
 
ProgramVersionAcademicYearId    INTEGER  NO 
 
GradeLevelId    INTEGER  NO 
 
BudgetId(FK)    INTEGER  YES 
 
Sequence    SMALLINT  NO 
 
FaAdvisorId    INTEGER  YES 
 
StartDate    DATETIME  NO 
 
EndDate    DATETIME  NO 
 
FirstAwardYear    CHAR(7)  NO 
 
SecondAwardYear    CHAR(7)  YES 
 
IsFirstTimeBorrower    BIT  NO 
 
PackageDate    DATETIME  YES 
 
PackagingStatusId(FK)    INTEGER  NO 
 
IsPackageRevised    BIT  NO 
 
AwardNoticePrintedDate    DATETIME  YES 
 
AwardNoticeSigned    DATETIME  YES 
 
RevisedAwardNoticePrinted    DATETIME  YES 
 
RevisedAwardNoticeSigned    DATETIME  YES 
 
WeeksInAcademicYear    NUMERIC(4, 1)  YES 
 
MonthsIncademicYear    NUMERIC(4, 1)  YES 
 
WeeksNonEnrollment    NUMERIC(4, 1)  YES 
 
CreditHoursInAcademicYear    NUMERIC(7, 2)  YES 
 
CostOfAttendance    MONEY(19, 4)  YES 
 
Tuition    MONEY(19, 4)  YES 
 
BooksSupplies    MONEY(19, 4)  YES 
 
RoomBoard    MONEY(19, 4)  YES 
 
Travel    MONEY(19, 4)  YES 
 
OtherCostDescription1    VARCHAR(40)  YES 
 
OtherCostAmount1    MONEY(19, 4)  YES 
 
OtherCostDescription2    VARCHAR(40)  YES 
 
OtherCostAmount2    MONEY(19, 4)  YES 
 
OtherCostDescription3    VARCHAR(40)  YES 
 
OtherCostAmount3    MONEY(19, 4)  YES 
 
OtherCostDescription4    VARCHAR(40)  YES 
 
OtherCostAmount4    MONEY(19, 4)  YES 
 
PellCostOfAttendance    MONEY(19, 4)  YES 
 
WeeksEnrolledInAcademicYear    INTEGER  YES 
 
CreditHoursExpectedToComplete    NUMERIC(9, 2)  YES 
 
Note    VARCHAR(4000)  YES 
 
BilledDate    DATETIME  YES 
 
LastModifiedUserId    INTEGER  NO 
 
CreatedDateTime    DATETIME  NO 
 
LastModifiedDateTime    DATETIME  NO 
 
RowVersion    TIMESTAMP/DATE  NO 
 
InstitutionalCharges    MONEY(19, 4)  YES 
 
PackagingMethodId    INTEGER  YES 
 
OtherCostAmount5    MONEY(19, 4)  YES 
 
OtherCostAmount6    MONEY(19, 4)  YES 
 
OtherCostAmount7    MONEY(19, 4)  YES 
 
OtherCostAmount8    MONEY(19, 4)  YES 
 
OtherCostDescription5    CHAR(40)  YES 
 
OtherCostDescription6    CHAR(40)  YES 
 
OtherCostDescription7    CHAR(40)  YES 
 
OtherCostDescription8    CHAR(40)  YES 
 
IsOtherCostInstitutionalCharge1    BIT  NO 
 
IsOtherCostInstitutionalCharge2    BIT  NO 
 
IsOtherCostInstitutionalCharge3    BIT  NO 
 
IsOtherCostInstitutionalCharge4    BIT  NO 
 
IsOtherCostInstitutionalCharge5    BIT  NO 
 
IsOtherCostInstitutionalCharge6    BIT  NO 
 
IsOtherCostInstitutionalCharge7    BIT  NO 
 
IsOtherCostInstitutionalCharge8    BIT  NO 
 
AcYrNote    VARCHAR(3000)  YES 
 
LenderFees    MONEY(19, 4)  NO 
 
BudgetRecordIdentifier    CHAR(20)  YES 
 
PackagedToEnrollmentStatusId    INTEGER  YES 
 
HousingStatusCode    CHAR(1)  YES 
 
IsHybridDates    BIT  NO 
 
SecondAwardYearPackagingStatusId(FK)    INTEGER  YES 
 
IsUnsubEligibilityUpToHeal    BIT  NO 
 
TeachCounselingDate    DATETIME  YES 
 
IsUnsupportedDependent    BIT  NO 
 
IsAutoAwardBudgetLock    BIT  NO 
 
IsAutoAwardPackageLock    BIT  NO 
 
AutoAwardEvaluationType    CHAR(1)  YES 
 
AutoAwardRequestProcess    VARCHAR(200)  YES 
 
HPPALevel    CHAR(1)  NO 
 
PLUSCreditDecisionStatus    CHAR(1)  YES 
 
IsSummerPackagingExcluded    BIT  NO 
 
AutoAwardConfigurationId(FK)    INTEGER  YES 
 
AutoAwardInitialCalculationDate    DATETIME  YES 
 
AutoAwardRepackageCalculationDate    DATETIME  YES 
 
IsReentryAcademicYear    BIT  YES 
 
IsStartDateExcluded    BIT  NO 
 
IsEndDateExcluded    BIT  NO 
 
CounselingCompleteDate    DATETIME  YES 
 
CounselingType    VARCHAR(50)  YES 
 
AutoAwardEnrollmentStatusId(FK)    INTEGER  YES 
 
IWINAY    NUMERIC(4, 1)  NO 
 
IWMonths    NUMERIC(4, 1)  NO 
 
RefWeeksInAcademicYear    NUMERIC(4, 1)  YES 
 
RefCreditHoursInAcademicYear    NUMERIC(7, 2)  YES 
 
TermsToPackageDirectLoan    VARCHAR(max)  NO 
 

StudentAcademicYear Keys 
Key Name  Key Type  Keys 
FaStudentAY_AwardYear1_N_N_IDX  Inversion Entry  FirstAwardYear 
NK_FaStudentAY_FirstTimeBorrower_INCL  Inversion Entry  IsFirstTimeBorrower 
Nk_FaStudentAyAutoAwardAdAttStatId  Inversion Entry  AutoAwardEnrollmentStatusId 
NK_FaStudentAYStartDate  Inversion Entry  StartDate 
FaStudentAY_FaPackStatusID_N_N_IDX  Inversion Entry  PackagingStatusId 
FaStudentAY_FaBudgetID_N_N_IDX  Inversion Entry  BudgetId 
FaStudentAY_StartDate_PackageDate_N_N_IDX  Inversion Entry  StartDate, PackageDate 
FaStudentAY_FaProgramAYSeqID_N_N_IDX  Inversion Entry  ProgramVersionAcademicYearId 
FaStudentAY_AwardYear2_N_N_IDX  Inversion Entry  SecondAwardYear 
Nk_FaStudentAy_AdEnrollID_FaPackStatusID_FaAutoAwardPopulationConfigurationId  Inversion Entry  AutoAwardConfigurationId 
Nk_FaStudentAyFaAutoAwardPopulationConfigurationId  Inversion Entry  AutoAwardConfigurationId 
FaStudentAY_EndDate_N_N_IDX  Inversion Entry  EndDate 
FaStudentAY_BudGetRecordId_N_N_IDX  Inversion Entry  BudgetRecordIdentifier 
FaStudentAY_FAStudentAYID_U_C_IDX  PrimaryKey  StudentAcademicYearId 
FaStudentAY_AdEnrollID_Sequence_N_N_IDX  Inversion Entry  StudentEnrollmentPeriodId, Sequence 
FaStudentAY_StartDate_EndDate_FaPackStatusID_AdEnrollID_N_N_IDX  Inversion Entry  StartDate, EndDate, PackagingStatusId, StudentEnrollmentPeriodId 
FaStudentAY_AdEnrollID_N_N_IDX  Inversion Entry  StudentEnrollmentPeriodId 

StudentAcademicYear Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
StudentEnrollmentPeriod  Non-Identifying  One To Zero or More        StudentEnrollmentPeriodId  NO 
PackagingStatus  Non-Identifying  Zero or One to Zero or More        SecondAwardYearPackagingStatusId  NO 
Budget  Non-Identifying  Zero or One to Zero or More        BudgetId  NO 
PackagingStatus  Non-Identifying  One To Zero or More        PackagingStatusId  NO 
EnrollmentStatus  Non-Identifying  Zero or One to Zero or More        AutoAwardEnrollmentStatusId  NO 
AutoAwardConfiguration  Non-Identifying  Zero or One to Zero or More        AutoAwardConfigurationId  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
AwardLetterPrintQueue  Non-Identifying  One To Zero or More          NO 
FaPackStatusQueue  Non-Identifying  One To Zero or More          NO 
StudentAcademicYearLoanPeriodDateAudit  Non-Identifying  One To Zero or More          NO 
StudentAward  Non-Identifying  One To Zero or More          NO 
FaStudentAidCashPlanHistory  Non-Identifying  One To Zero or More          NO 
StudentAcademicYearComment  Non-Identifying  One To Zero or More          NO 
StudentAcademicYearPaymentPeriod  Non-Identifying  One To Zero or More          NO 
FaStudentMaster  Non-Identifying  One To Zero or More          NO 
HousingLease  Non-Identifying  One To Zero or More          NO 
SyAudit_FaStudentAY  Non-Identifying  One To Zero or More          NO 
SyAudit_FaStudentAYPaymentPeriod  Non-Identifying  One To Zero or More          NO 
StudentRt4Calculation  Non-Identifying  One To Zero or More          NO 

StudentAcademicYear Check Constraints 
Check Constraint Name  CheckConstraint 

StudentAcademicYear Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.StudentAcademicYear 
NO       
Physical (Microsoft SQL Server)
dbo.FaStudentAY 
NO       

StudentAcademicYear Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  RefundCalculation 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Financial Aid 

StudentAcademicYear Data Movement Rules 
Name  Type  Rule Text/Value